CREATE TABLE [dbo].[TRCOCO_DESC]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[TI_COMP_COBR] [dbo].[TD_VC_003] NOT NULL,
[CO_DESC] [dbo].[TD_VC_008] NOT NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRCOCO_DE__CO_US__4B180DA3] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRCOCO_DE__FE_US__4C0C31DC] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRCOCO_DE__CO_US__4D005615] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRCOCO_DE__FE_US__4DF47A4E] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRCOCO_DESC] ADD CONSTRAINT [PK__TRCOCO_D__08355F4A03324994] PRIMARY KEY CLUSTERED  ([CO_EMPR], [TI_COMP_COBR], [CO_DESC]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRCOCO_DESC] ADD CONSTRAINT [FK__TRCOCO_DESC__1B29CEB6] FOREIGN KEY ([CO_EMPR], [TI_COMP_COBR]) REFERENCES [dbo].[TTTIPO_COCO] ([CO_EMPR], [TI_COMP_COBR])
GO
